﻿CREATE TABLE [dbo].[t_Interviews] (
    [ID]         INT            IDENTITY (1, 1) NOT NULL,
    [BorrowerID] INT            NOT NULL,
    [DoneBy]     NVARCHAR (50)  NULL,
    [Weight]     INT            NOT NULL,
    [Date]       SMALLDATETIME  NULL,
    [Date_F]     AS             ((CONVERT([varchar],[Date],(101))+' ')+substring(CONVERT([varchar],[Date],(8)),(1),(5))),
    [UserName]   NVARCHAR (128) NULL,
    [Note]       NVARCHAR (512) NULL
);

